<?php
	/**
	 * The abstract TableUserProfileGen class defined here is
	 * code-generated and contains all the basic CRUD-type functionality as well as
	 * basic methods to handle relationships and index-based loading.
	 *
	 * To use, you should use the TableUserProfile subclass which
	 * extends this TableUserProfileGen class.
	 *
	 * Because subsequent re-code generations will overwrite any changes to this
	 * file, you should leave this file unaltered to prevent yourself from losing
	 * any information or code changes.  All customizations should be done by
	 * overriding existing or implementing new methods, properties and variables
	 * in the TableUserProfile class.
	 * 
	 * @package My Application
	 * @subpackage GeneratedDataObjects
	 * @property-read integer $Id the value for intId (Read-Only PK)
	 * @property integer $UserId the value for intUserId (Not Null)
	 * @property string $CompanyUser the value for strCompanyUser (Not Null)
	 * @property string $CatchPhrase the value for strCatchPhrase 
	 * @property string $LanguageDescription the value for strLanguageDescription 
	 * @property string $KeywordDescription the value for strKeywordDescription 
	 * @property string $Message the value for strMessage 
	 * @property string $Location the value for strLocation 
	 * @property integer $CustomerCount the value for intCustomerCount (Not Null)
	 * @property integer $RepeaterCount the value for intRepeaterCount (Not Null)
	 * @property integer $WonProjectCount the value for intWonProjectCount (Not Null)
	 * @property integer $CompletedWonProjectCount the value for intCompletedWonProjectCount (Not Null)
	 * @property integer $FailedWonProjectCount the value for intFailedWonProjectCount (Not Null)
	 * @property integer $PostProjectCount the value for intPostProjectCount (Not Null)
	 * @property integer $CompletedPostProjectCount the value for intCompletedPostProjectCount (Not Null)
	 * @property integer $FailedPostProjectCount the value for intFailedPostProjectCount (Not Null)
	 * @property integer $BidProjectCount the value for intBidProjectCount (Not Null)
	 * @property integer $BidProjectCountThisMonth the value for intBidProjectCountThisMonth (Not Null)
	 * @property integer $WonProjectReviewCount the value for intWonProjectReviewCount (Not Null)
	 * @property integer $WonProjectPositiveReviewCount the value for intWonProjectPositiveReviewCount (Not Null)
	 * @property integer $WonProjectNeutralReviewCount the value for intWonProjectNeutralReviewCount (Not Null)
	 * @property integer $WonProjectNegativeReviewCount the value for intWonProjectNegativeReviewCount (Not Null)
	 * @property integer $PostProjectReviewCount the value for intPostProjectReviewCount (Not Null)
	 * @property integer $PostProjectPositiveReviewCount the value for intPostProjectPositiveReviewCount (Not Null)
	 * @property integer $PostProjectNeutralReviewCount the value for intPostProjectNeutralReviewCount (Not Null)
	 * @property integer $PostProjectNegativeReviewCount the value for intPostProjectNegativeReviewCount (Not Null)
	 * @property integer $SuspendCount the value for intSuspendCount (Not Null)
	 * @property string $PaypalEmail the value for strPaypalEmail (Not Null)
	 * @property string $LimitedIp the value for strLimitedIp 
	 * @property QDateTime $UpdateDate the value for dttUpdateDate 
	 * @property string $Vision the value for strVision 
	 * @property string $AreaOfExpertise the value for strAreaOfExpertise 
	 * @property double $CompletionRatio the value for fltCompletionRatio (Not Null)
	 * @property double $BudgetPaidRatio the value for fltBudgetPaidRatio (Not Null)
	 * @property integer $PaginationNumber the value for intPaginationNumber (Not Null)
	 * @property integer $LandingPage the value for intLandingPage 
	 * @property TableUserProject $User the value for the TableUserProject object referenced by intUserId (Not Null)
	 * @property-read boolean $__Restored whether or not this object was restored from the database (as opposed to created new)
	 */
	class TableUserProfileGen extends QBaseClass {

		///////////////////////////////////////////////////////////////////////
		// PROTECTED MEMBER VARIABLES and TEXT FIELD MAXLENGTHS (if applicable)
		///////////////////////////////////////////////////////////////////////
		
		/**
		 * Protected member variable that maps to the database PK Identity column table_user_profile.id
		 * @var integer intId
		 */
		protected $intId;
		const IdDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.user_id
		 * @var integer intUserId
		 */
		protected $intUserId;
		const UserIdDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.company_user
		 * @var string strCompanyUser
		 */
		protected $strCompanyUser;
		const CompanyUserMaxLength = 1;
		const CompanyUserDefault = null;


		/**
		 * Protected member variable that maps to the database column table_user_profile.catch_phrase
		 * @var string strCatchPhrase
		 */
		protected $strCatchPhrase;
		const CatchPhraseMaxLength = 200;
		const CatchPhraseDefault = null;


		/**
		 * Protected member variable that maps to the database column table_user_profile.language_description
		 * @var string strLanguageDescription
		 */
		protected $strLanguageDescription;
		const LanguageDescriptionDefault = null;


		/**
		 * Protected member variable that maps to the database column table_user_profile.keyword_description
		 * @var string strKeywordDescription
		 */
		protected $strKeywordDescription;
		const KeywordDescriptionDefault = null;


		/**
		 * Protected member variable that maps to the database column table_user_profile.message
		 * @var string strMessage
		 */
		protected $strMessage;
		const MessageDefault = null;


		/**
		 * Protected member variable that maps to the database column table_user_profile.location
		 * @var string strLocation
		 */
		protected $strLocation;
		const LocationMaxLength = 100;
		const LocationDefault = null;


		/**
		 * Protected member variable that maps to the database column table_user_profile.customer_count
		 * @var integer intCustomerCount
		 */
		protected $intCustomerCount;
		const CustomerCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.repeater_count
		 * @var integer intRepeaterCount
		 */
		protected $intRepeaterCount;
		const RepeaterCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.won_project_count
		 * @var integer intWonProjectCount
		 */
		protected $intWonProjectCount;
		const WonProjectCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.completed_won_project_count
		 * @var integer intCompletedWonProjectCount
		 */
		protected $intCompletedWonProjectCount;
		const CompletedWonProjectCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.failed_won_project_count
		 * @var integer intFailedWonProjectCount
		 */
		protected $intFailedWonProjectCount;
		const FailedWonProjectCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.post_project_count
		 * @var integer intPostProjectCount
		 */
		protected $intPostProjectCount;
		const PostProjectCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.completed_post_project_count
		 * @var integer intCompletedPostProjectCount
		 */
		protected $intCompletedPostProjectCount;
		const CompletedPostProjectCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.failed_post_project_count
		 * @var integer intFailedPostProjectCount
		 */
		protected $intFailedPostProjectCount;
		const FailedPostProjectCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.bid_project_count
		 * @var integer intBidProjectCount
		 */
		protected $intBidProjectCount;
		const BidProjectCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.bid_project_count_this_month
		 * @var integer intBidProjectCountThisMonth
		 */
		protected $intBidProjectCountThisMonth;
		const BidProjectCountThisMonthDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.won_project_review_count
		 * @var integer intWonProjectReviewCount
		 */
		protected $intWonProjectReviewCount;
		const WonProjectReviewCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.won_project_positive_review_count
		 * @var integer intWonProjectPositiveReviewCount
		 */
		protected $intWonProjectPositiveReviewCount;
		const WonProjectPositiveReviewCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.won_project_neutral_review_count
		 * @var integer intWonProjectNeutralReviewCount
		 */
		protected $intWonProjectNeutralReviewCount;
		const WonProjectNeutralReviewCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.won_project_negative_review_count
		 * @var integer intWonProjectNegativeReviewCount
		 */
		protected $intWonProjectNegativeReviewCount;
		const WonProjectNegativeReviewCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.post_project_review_count
		 * @var integer intPostProjectReviewCount
		 */
		protected $intPostProjectReviewCount;
		const PostProjectReviewCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.post_project_positive_review_count
		 * @var integer intPostProjectPositiveReviewCount
		 */
		protected $intPostProjectPositiveReviewCount;
		const PostProjectPositiveReviewCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.post_project_neutral_review_count
		 * @var integer intPostProjectNeutralReviewCount
		 */
		protected $intPostProjectNeutralReviewCount;
		const PostProjectNeutralReviewCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.post_project_negative_review_count
		 * @var integer intPostProjectNegativeReviewCount
		 */
		protected $intPostProjectNegativeReviewCount;
		const PostProjectNegativeReviewCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.suspend_count
		 * @var integer intSuspendCount
		 */
		protected $intSuspendCount;
		const SuspendCountDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.paypal_email
		 * @var string strPaypalEmail
		 */
		protected $strPaypalEmail;
		const PaypalEmailMaxLength = 200;
		const PaypalEmailDefault = null;


		/**
		 * Protected member variable that maps to the database column table_user_profile.limited_ip
		 * @var string strLimitedIp
		 */
		protected $strLimitedIp;
		const LimitedIpDefault = null;


		/**
		 * Protected member variable that maps to the database column table_user_profile.update_date
		 * @var QDateTime dttUpdateDate
		 */
		protected $dttUpdateDate;
		const UpdateDateDefault = null;


		/**
		 * Protected member variable that maps to the database column table_user_profile.vision
		 * @var string strVision
		 */
		protected $strVision;
		const VisionDefault = null;


		/**
		 * Protected member variable that maps to the database column table_user_profile.area_of_expertise
		 * @var string strAreaOfExpertise
		 */
		protected $strAreaOfExpertise;
		const AreaOfExpertiseDefault = null;


		/**
		 * Protected member variable that maps to the database column table_user_profile.completion_ratio
		 * @var double fltCompletionRatio
		 */
		protected $fltCompletionRatio;
		const CompletionRatioDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.budget_paid_ratio
		 * @var double fltBudgetPaidRatio
		 */
		protected $fltBudgetPaidRatio;
		const BudgetPaidRatioDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.pagination_number
		 * @var integer intPaginationNumber
		 */
		protected $intPaginationNumber;
		const PaginationNumberDefault = 0;


		/**
		 * Protected member variable that maps to the database column table_user_profile.landing_page
		 * @var integer intLandingPage
		 */
		protected $intLandingPage;
		const LandingPageDefault = null;


		/**
		 * Protected array of virtual attributes for this object (e.g. extra/other calculated and/or non-object bound
		 * columns from the run-time database query result for this object).  Used by InstantiateDbRow and
		 * GetVirtualAttribute.
		 * @var string[] $__strVirtualAttributeArray
		 */
		protected $__strVirtualAttributeArray = array();

		/**
		 * Protected internal member variable that specifies whether or not this object is Restored from the database.
		 * Used by Save() to determine if Save() should perform a db UPDATE or INSERT.
		 * @var bool __blnRestored;
		 */
		protected $__blnRestored;




		///////////////////////////////
		// PROTECTED MEMBER OBJECTS
		///////////////////////////////

		/**
		 * Protected member variable that contains the object pointed by the reference
		 * in the database column table_user_profile.user_id.
		 *
		 * NOTE: Always use the User property getter to correctly retrieve this TableUserProject object.
		 * (Because this class implements late binding, this variable reference MAY be null.)
		 * @var TableUserProject objUser
		 */
		protected $objUser;





		///////////////////////////////
		// CLASS-WIDE LOAD AND COUNT METHODS
		///////////////////////////////

		/**
		 * Static method to retrieve the Database object that owns this class.
		 * @return QDatabaseBase reference to the Database object that can query this class
		 */
		public static function GetDatabase() {
			return QApplication::$Database[1];
		}

		/**
		 * Load a TableUserProfile from PK Info
		 * @param integer $intId
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile
		 */
		public static function Load($intId, $objOptionalClauses = null) {
			// Use QuerySingle to Perform the Query
			return TableUserProfile::QuerySingle(
				QQ::AndCondition(
					QQ::Equal(QQN::TableUserProfile()->Id, $intId)
				),
				$objOptionalClauses
			);
		}

		/**
		 * Load all TableUserProfiles
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		 */
		public static function LoadAll($objOptionalClauses = null) {
			if (func_num_args() > 1) {
				throw new QCallerException("LoadAll must be called with an array of optional clauses as a single argument");
			}
			// Call TableUserProfile::QueryArray to perform the LoadAll query
			try {
				return TableUserProfile::QueryArray(QQ::All(), $objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count all TableUserProfiles
		 * @return int
		 */
		public static function CountAll() {
			// Call TableUserProfile::QueryCount to perform the CountAll query
			return TableUserProfile::QueryCount(QQ::All());
		}




		///////////////////////////////
		// QCUBED QUERY-RELATED METHODS
		///////////////////////////////

		/**
		 * Internally called method to assist with calling Qcubed Query for this class
		 * on load methods.
		 * @param QQueryBuilder &$objQueryBuilder the QueryBuilder object that will be created
		 * @param QQCondition $objConditions any conditions on the query, itself
		 * @param QQClause[] $objOptionalClausees additional optional QQClause object or array of QQClause objects for this query
		 * @param mixed[] $mixParameterArray a array of name-value pairs to perform PrepareStatement with (sending in null will skip the PrepareStatement step)
		 * @param boolean $blnCountOnly only select a rowcount
		 * @return string the query statement
		 */
		protected static function BuildQueryStatement(&$objQueryBuilder, QQCondition $objConditions, $objOptionalClauses, $mixParameterArray, $blnCountOnly) {
			// Get the Database Object for this Class
			$objDatabase = TableUserProfile::GetDatabase();

			// Create/Build out the QueryBuilder object with TableUserProfile-specific SELET and FROM fields
			$objQueryBuilder = new QQueryBuilder($objDatabase, 'table_user_profile');
			TableUserProfile::GetSelectFields($objQueryBuilder);
			$objQueryBuilder->AddFromItem('table_user_profile');

			// Set "CountOnly" option (if applicable)
			if ($blnCountOnly)
				$objQueryBuilder->SetCountOnlyFlag();

			// Apply Any Conditions
			if ($objConditions)
				try {
					$objConditions->UpdateQueryBuilder($objQueryBuilder);
				} catch (QCallerException $objExc) {
					$objExc->IncrementOffset();
					throw $objExc;
				}

			// Iterate through all the Optional Clauses (if any) and perform accordingly
			if ($objOptionalClauses) {
				if ($objOptionalClauses instanceof QQClause)
					$objOptionalClauses->UpdateQueryBuilder($objQueryBuilder);
				else if (is_array($objOptionalClauses))
					foreach ($objOptionalClauses as $objClause)
						$objClause->UpdateQueryBuilder($objQueryBuilder);
				else
					throw new QCallerException('Optional Clauses must be a QQClause object or an array of QQClause objects');
			}

			// Get the SQL Statement
			$strQuery = $objQueryBuilder->GetStatement();

			// Prepare the Statement with the Query Parameters (if applicable)
			if ($mixParameterArray) {
				if (is_array($mixParameterArray)) {
					if (count($mixParameterArray))
						$strQuery = $objDatabase->PrepareStatement($strQuery, $mixParameterArray);

					// Ensure that there are no other Unresolved Named Parameters
					if (strpos($strQuery, chr(QQNamedValue::DelimiterCode) . '{') !== false)
						throw new QCallerException('Unresolved named parameters in the query');
				} else
					throw new QCallerException('Parameter Array must be an array of name-value parameter pairs');
			}

			// Return the Objects
			return $strQuery;
		}

		/**
		 * Static Qcubed Query method to query for a single TableUserProfile object.
		 * Uses BuildQueryStatment to perform most of the work.
		 * @param QQCondition $objConditions any conditions on the query, itself
		 * @param QQClause[] $objOptionalClausees additional optional QQClause objects for this query
		 * @param mixed[] $mixParameterArray a array of name-value pairs to perform PrepareStatement with
		 * @return TableUserProfile the queried object
		 */
		public static function QuerySingle(QQCondition $objConditions, $objOptionalClauses = null, $mixParameterArray = null) {
			// Get the Query Statement
			try {
				$strQuery = TableUserProfile::BuildQueryStatement($objQueryBuilder, $objConditions, $objOptionalClauses, $mixParameterArray, false);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
			
			// Perform the Query, Get the First Row, and Instantiate a new TableUserProfile object
			$objDbResult = $objQueryBuilder->Database->Query($strQuery);
			
			// Do we have to expand anything?
			if ($objQueryBuilder->ExpandAsArrayNodes) {
				$objToReturn = array();
				while ($objDbRow = $objDbResult->GetNextRow()) {
					$objItem = TableUserProfile::InstantiateDbRow($objDbRow, null, $objQueryBuilder->ExpandAsArrayNodes, $objToReturn, $objQueryBuilder->ColumnAliasArray);
					if ($objItem)
						$objToReturn[] = $objItem;					
				}			
				// Since we only want the object to return, lets return the object and not the array.
				return $objToReturn[0];
			} else {
				// No expands just return the first row
				$objToReturn = null;
				while ($objDbRow = $objDbResult->GetNextRow())
					$objToReturn = TableUserProfile::InstantiateDbRow($objDbRow, null, null, null, $objQueryBuilder->ColumnAliasArray);
			}
			
			return $objToReturn;
		}

		/**
		 * Static Qcubed Query method to query for an array of TableUserProfile objects.
		 * Uses BuildQueryStatment to perform most of the work.
		 * @param QQCondition $objConditions any conditions on the query, itself
		 * @param QQClause[] $objOptionalClausees additional optional QQClause objects for this query
		 * @param mixed[] $mixParameterArray a array of name-value pairs to perform PrepareStatement with
		 * @return TableUserProfile[] the queried objects as an array
		 */
		public static function QueryArray(QQCondition $objConditions, $objOptionalClauses = null, $mixParameterArray = null) {
			// Get the Query Statement
			try {
				$strQuery = TableUserProfile::BuildQueryStatement($objQueryBuilder, $objConditions, $objOptionalClauses, $mixParameterArray, false);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}

			// Perform the Query and Instantiate the Array Result
			$objDbResult = $objQueryBuilder->Database->Query($strQuery);
			return TableUserProfile::InstantiateDbResult($objDbResult, $objQueryBuilder->ExpandAsArrayNodes, $objQueryBuilder->ColumnAliasArray);
		}

		/**
		 * Static Qcubed Query method to query for a count of TableUserProfile objects.
		 * Uses BuildQueryStatment to perform most of the work.
		 * @param QQCondition $objConditions any conditions on the query, itself
		 * @param QQClause[] $objOptionalClausees additional optional QQClause objects for this query
		 * @param mixed[] $mixParameterArray a array of name-value pairs to perform PrepareStatement with
		 * @return integer the count of queried objects as an integer
		 */
		public static function QueryCount(QQCondition $objConditions, $objOptionalClauses = null, $mixParameterArray = null) {
			// Get the Query Statement
			try {
				$strQuery = TableUserProfile::BuildQueryStatement($objQueryBuilder, $objConditions, $objOptionalClauses, $mixParameterArray, true);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}

			// Perform the Query and return the row_count
			$objDbResult = $objQueryBuilder->Database->Query($strQuery);

			// Figure out if the query is using GroupBy
			$blnGrouped = false;

			if ($objOptionalClauses) foreach ($objOptionalClauses as $objClause) {
				if ($objClause instanceof QQGroupBy) {
					$blnGrouped = true;
					break;
				}
			}

			if ($blnGrouped)
				// Groups in this query - return the count of Groups (which is the count of all rows)
				return $objDbResult->CountRows();
			else {
				// No Groups - return the sql-calculated count(*) value
				$strDbRow = $objDbResult->FetchRow();
				return QType::Cast($strDbRow[0], QType::Integer);
			}
		}

		public static function QueryArrayCached(QQCondition $objConditions, $objOptionalClauses = null, $mixParameterArray = null, $blnForceUpdate = false) {
			// Get the Database Object for this Class
			$objDatabase = TableUserProfile::GetDatabase();

			$strQuery = TableUserProfile::BuildQueryStatement($objQueryBuilder, $objConditions, $objOptionalClauses, $mixParameterArray, false);
			
			$objCache = new QCache('qquery/tableuserprofile', $strQuery);
			$cacheData = $objCache->GetData();
			
			if (!$cacheData || $blnForceUpdate) {
				$objDbResult = $objQueryBuilder->Database->Query($strQuery);
				$arrResult = TableUserProfile::InstantiateDbResult($objDbResult, $objQueryBuilder->ExpandAsArrayNodes, $objQueryBuilder->ColumnAliasArray);
				$objCache->SaveData(serialize($arrResult));
			} else {
				$arrResult = unserialize($cacheData);
			}
			
			return $arrResult;
		}

		/**
		 * Updates a QQueryBuilder with the SELECT fields for this TableUserProfile
		 * @param QQueryBuilder $objBuilder the Query Builder object to update
		 * @param string $strPrefix optional prefix to add to the SELECT fields
		 */
		public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null) {
			if ($strPrefix) {
				$strTableName = $strPrefix;
				$strAliasPrefix = $strPrefix . '__';
			} else {
				$strTableName = 'table_user_profile';
				$strAliasPrefix = '';
			}

			$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
			$objBuilder->AddSelectItem($strTableName, 'user_id', $strAliasPrefix . 'user_id');
			$objBuilder->AddSelectItem($strTableName, 'company_user', $strAliasPrefix . 'company_user');
			$objBuilder->AddSelectItem($strTableName, 'catch_phrase', $strAliasPrefix . 'catch_phrase');
			$objBuilder->AddSelectItem($strTableName, 'language_description', $strAliasPrefix . 'language_description');
			$objBuilder->AddSelectItem($strTableName, 'keyword_description', $strAliasPrefix . 'keyword_description');
			$objBuilder->AddSelectItem($strTableName, 'message', $strAliasPrefix . 'message');
			$objBuilder->AddSelectItem($strTableName, 'location', $strAliasPrefix . 'location');
			$objBuilder->AddSelectItem($strTableName, 'customer_count', $strAliasPrefix . 'customer_count');
			$objBuilder->AddSelectItem($strTableName, 'repeater_count', $strAliasPrefix . 'repeater_count');
			$objBuilder->AddSelectItem($strTableName, 'won_project_count', $strAliasPrefix . 'won_project_count');
			$objBuilder->AddSelectItem($strTableName, 'completed_won_project_count', $strAliasPrefix . 'completed_won_project_count');
			$objBuilder->AddSelectItem($strTableName, 'failed_won_project_count', $strAliasPrefix . 'failed_won_project_count');
			$objBuilder->AddSelectItem($strTableName, 'post_project_count', $strAliasPrefix . 'post_project_count');
			$objBuilder->AddSelectItem($strTableName, 'completed_post_project_count', $strAliasPrefix . 'completed_post_project_count');
			$objBuilder->AddSelectItem($strTableName, 'failed_post_project_count', $strAliasPrefix . 'failed_post_project_count');
			$objBuilder->AddSelectItem($strTableName, 'bid_project_count', $strAliasPrefix . 'bid_project_count');
			$objBuilder->AddSelectItem($strTableName, 'bid_project_count_this_month', $strAliasPrefix . 'bid_project_count_this_month');
			$objBuilder->AddSelectItem($strTableName, 'won_project_review_count', $strAliasPrefix . 'won_project_review_count');
			$objBuilder->AddSelectItem($strTableName, 'won_project_positive_review_count', $strAliasPrefix . 'won_project_positive_review_count');
			$objBuilder->AddSelectItem($strTableName, 'won_project_neutral_review_count', $strAliasPrefix . 'won_project_neutral_review_count');
			$objBuilder->AddSelectItem($strTableName, 'won_project_negative_review_count', $strAliasPrefix . 'won_project_negative_review_count');
			$objBuilder->AddSelectItem($strTableName, 'post_project_review_count', $strAliasPrefix . 'post_project_review_count');
			$objBuilder->AddSelectItem($strTableName, 'post_project_positive_review_count', $strAliasPrefix . 'post_project_positive_review_count');
			$objBuilder->AddSelectItem($strTableName, 'post_project_neutral_review_count', $strAliasPrefix . 'post_project_neutral_review_count');
			$objBuilder->AddSelectItem($strTableName, 'post_project_negative_review_count', $strAliasPrefix . 'post_project_negative_review_count');
			$objBuilder->AddSelectItem($strTableName, 'suspend_count', $strAliasPrefix . 'suspend_count');
			$objBuilder->AddSelectItem($strTableName, 'paypal_email', $strAliasPrefix . 'paypal_email');
			$objBuilder->AddSelectItem($strTableName, 'limited_ip', $strAliasPrefix . 'limited_ip');
			$objBuilder->AddSelectItem($strTableName, 'update_date', $strAliasPrefix . 'update_date');
			$objBuilder->AddSelectItem($strTableName, 'vision', $strAliasPrefix . 'vision');
			$objBuilder->AddSelectItem($strTableName, 'area_of_expertise', $strAliasPrefix . 'area_of_expertise');
			$objBuilder->AddSelectItem($strTableName, 'completion_ratio', $strAliasPrefix . 'completion_ratio');
			$objBuilder->AddSelectItem($strTableName, 'budget_paid_ratio', $strAliasPrefix . 'budget_paid_ratio');
			$objBuilder->AddSelectItem($strTableName, 'pagination_number', $strAliasPrefix . 'pagination_number');
			$objBuilder->AddSelectItem($strTableName, 'landing_page', $strAliasPrefix . 'landing_page');
		}



		///////////////////////////////
		// INSTANTIATION-RELATED METHODS
		///////////////////////////////

		/**
		 * Instantiate a TableUserProfile from a Database Row.
		 * Takes in an optional strAliasPrefix, used in case another Object::InstantiateDbRow
		 * is calling this TableUserProfile::InstantiateDbRow in order to perform
		 * early binding on referenced objects.
		 * @param DatabaseRowBase $objDbRow
		 * @param string $strAliasPrefix
		 * @param string $strExpandAsArrayNodes
		 * @param QBaseClass $arrPreviousItem
		 * @param string[] $strColumnAliasArray
		 * @return TableUserProfile
		*/
		public static function InstantiateDbRow($objDbRow, $strAliasPrefix = null, $strExpandAsArrayNodes = null, $arrPreviousItems = null, $strColumnAliasArray = array()) {
			// If blank row, return null
			if (!$objDbRow) {
				return null;
			}

			// Create a new instance of the TableUserProfile object
			$objToReturn = new TableUserProfile();
			$objToReturn->__blnRestored = true;

			$strAliasName = array_key_exists($strAliasPrefix . 'id', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'id'] : $strAliasPrefix . 'id';
			$objToReturn->intId = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'user_id', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'user_id'] : $strAliasPrefix . 'user_id';
			$objToReturn->intUserId = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'company_user', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'company_user'] : $strAliasPrefix . 'company_user';
			$objToReturn->strCompanyUser = $objDbRow->GetColumn($strAliasName, 'VarChar');
			$strAliasName = array_key_exists($strAliasPrefix . 'catch_phrase', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'catch_phrase'] : $strAliasPrefix . 'catch_phrase';
			$objToReturn->strCatchPhrase = $objDbRow->GetColumn($strAliasName, 'VarChar');
			$strAliasName = array_key_exists($strAliasPrefix . 'language_description', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'language_description'] : $strAliasPrefix . 'language_description';
			$objToReturn->strLanguageDescription = $objDbRow->GetColumn($strAliasName, 'Blob');
			$strAliasName = array_key_exists($strAliasPrefix . 'keyword_description', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'keyword_description'] : $strAliasPrefix . 'keyword_description';
			$objToReturn->strKeywordDescription = $objDbRow->GetColumn($strAliasName, 'Blob');
			$strAliasName = array_key_exists($strAliasPrefix . 'message', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'message'] : $strAliasPrefix . 'message';
			$objToReturn->strMessage = $objDbRow->GetColumn($strAliasName, 'Blob');
			$strAliasName = array_key_exists($strAliasPrefix . 'location', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'location'] : $strAliasPrefix . 'location';
			$objToReturn->strLocation = $objDbRow->GetColumn($strAliasName, 'VarChar');
			$strAliasName = array_key_exists($strAliasPrefix . 'customer_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'customer_count'] : $strAliasPrefix . 'customer_count';
			$objToReturn->intCustomerCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'repeater_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'repeater_count'] : $strAliasPrefix . 'repeater_count';
			$objToReturn->intRepeaterCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'won_project_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'won_project_count'] : $strAliasPrefix . 'won_project_count';
			$objToReturn->intWonProjectCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'completed_won_project_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'completed_won_project_count'] : $strAliasPrefix . 'completed_won_project_count';
			$objToReturn->intCompletedWonProjectCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'failed_won_project_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'failed_won_project_count'] : $strAliasPrefix . 'failed_won_project_count';
			$objToReturn->intFailedWonProjectCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'post_project_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'post_project_count'] : $strAliasPrefix . 'post_project_count';
			$objToReturn->intPostProjectCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'completed_post_project_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'completed_post_project_count'] : $strAliasPrefix . 'completed_post_project_count';
			$objToReturn->intCompletedPostProjectCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'failed_post_project_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'failed_post_project_count'] : $strAliasPrefix . 'failed_post_project_count';
			$objToReturn->intFailedPostProjectCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'bid_project_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'bid_project_count'] : $strAliasPrefix . 'bid_project_count';
			$objToReturn->intBidProjectCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'bid_project_count_this_month', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'bid_project_count_this_month'] : $strAliasPrefix . 'bid_project_count_this_month';
			$objToReturn->intBidProjectCountThisMonth = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'won_project_review_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'won_project_review_count'] : $strAliasPrefix . 'won_project_review_count';
			$objToReturn->intWonProjectReviewCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'won_project_positive_review_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'won_project_positive_review_count'] : $strAliasPrefix . 'won_project_positive_review_count';
			$objToReturn->intWonProjectPositiveReviewCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'won_project_neutral_review_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'won_project_neutral_review_count'] : $strAliasPrefix . 'won_project_neutral_review_count';
			$objToReturn->intWonProjectNeutralReviewCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'won_project_negative_review_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'won_project_negative_review_count'] : $strAliasPrefix . 'won_project_negative_review_count';
			$objToReturn->intWonProjectNegativeReviewCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'post_project_review_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'post_project_review_count'] : $strAliasPrefix . 'post_project_review_count';
			$objToReturn->intPostProjectReviewCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'post_project_positive_review_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'post_project_positive_review_count'] : $strAliasPrefix . 'post_project_positive_review_count';
			$objToReturn->intPostProjectPositiveReviewCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'post_project_neutral_review_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'post_project_neutral_review_count'] : $strAliasPrefix . 'post_project_neutral_review_count';
			$objToReturn->intPostProjectNeutralReviewCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'post_project_negative_review_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'post_project_negative_review_count'] : $strAliasPrefix . 'post_project_negative_review_count';
			$objToReturn->intPostProjectNegativeReviewCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'suspend_count', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'suspend_count'] : $strAliasPrefix . 'suspend_count';
			$objToReturn->intSuspendCount = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'paypal_email', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'paypal_email'] : $strAliasPrefix . 'paypal_email';
			$objToReturn->strPaypalEmail = $objDbRow->GetColumn($strAliasName, 'VarChar');
			$strAliasName = array_key_exists($strAliasPrefix . 'limited_ip', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'limited_ip'] : $strAliasPrefix . 'limited_ip';
			$objToReturn->strLimitedIp = $objDbRow->GetColumn($strAliasName, 'Blob');
			$strAliasName = array_key_exists($strAliasPrefix . 'update_date', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'update_date'] : $strAliasPrefix . 'update_date';
			$objToReturn->dttUpdateDate = $objDbRow->GetColumn($strAliasName, 'DateTime');
			$strAliasName = array_key_exists($strAliasPrefix . 'vision', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'vision'] : $strAliasPrefix . 'vision';
			$objToReturn->strVision = $objDbRow->GetColumn($strAliasName, 'Blob');
			$strAliasName = array_key_exists($strAliasPrefix . 'area_of_expertise', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'area_of_expertise'] : $strAliasPrefix . 'area_of_expertise';
			$objToReturn->strAreaOfExpertise = $objDbRow->GetColumn($strAliasName, 'Blob');
			$strAliasName = array_key_exists($strAliasPrefix . 'completion_ratio', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'completion_ratio'] : $strAliasPrefix . 'completion_ratio';
			$objToReturn->fltCompletionRatio = $objDbRow->GetColumn($strAliasName, 'Float');
			$strAliasName = array_key_exists($strAliasPrefix . 'budget_paid_ratio', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'budget_paid_ratio'] : $strAliasPrefix . 'budget_paid_ratio';
			$objToReturn->fltBudgetPaidRatio = $objDbRow->GetColumn($strAliasName, 'Float');
			$strAliasName = array_key_exists($strAliasPrefix . 'pagination_number', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'pagination_number'] : $strAliasPrefix . 'pagination_number';
			$objToReturn->intPaginationNumber = $objDbRow->GetColumn($strAliasName, 'Integer');
			$strAliasName = array_key_exists($strAliasPrefix . 'landing_page', $strColumnAliasArray) ? $strColumnAliasArray[$strAliasPrefix . 'landing_page'] : $strAliasPrefix . 'landing_page';
			$objToReturn->intLandingPage = $objDbRow->GetColumn($strAliasName, 'Integer');

			if (isset($arrPreviousItems) && is_array($arrPreviousItems)) {
				foreach ($arrPreviousItems as $objPreviousItem) {
					if ($objToReturn->Id != $objPreviousItem->Id) {
						continue;
					}

					// complete match - all primary key columns are the same
					return null;
				}
			}

			// Instantiate Virtual Attributes
			foreach ($objDbRow->GetColumnNameArray() as $strColumnName => $mixValue) {
				$strVirtualPrefix = $strAliasPrefix . '__';
				$strVirtualPrefixLength = strlen($strVirtualPrefix);
				if (substr($strColumnName, 0, $strVirtualPrefixLength) == $strVirtualPrefix)
					$objToReturn->__strVirtualAttributeArray[substr($strColumnName, $strVirtualPrefixLength)] = $mixValue;
			}

			// Prepare to Check for Early/Virtual Binding
			if (!$strAliasPrefix)
				$strAliasPrefix = 'table_user_profile__';

			// Check for User Early Binding
			$strAlias = $strAliasPrefix . 'user_id__id';
			$strAliasName = array_key_exists($strAlias, $strColumnAliasArray) ? $strColumnAliasArray[$strAlias] : $strAlias;
			if (!is_null($objDbRow->GetColumn($strAliasName)))
				$objToReturn->objUser = TableUserProject::InstantiateDbRow($objDbRow, $strAliasPrefix . 'user_id__', $strExpandAsArrayNodes, null, $strColumnAliasArray);




			return $objToReturn;
		}

		/**
		 * Instantiate an array of TableUserProfiles from a Database Result
		 * @param DatabaseResultBase $objDbResult
		 * @param string $strExpandAsArrayNodes
		 * @param string[] $strColumnAliasArray
		 * @return TableUserProfile[]
		 */
		public static function InstantiateDbResult(QDatabaseResultBase $objDbResult, $strExpandAsArrayNodes = null, $strColumnAliasArray = null) {
			$objToReturn = array();
			
			if (!$strColumnAliasArray)
				$strColumnAliasArray = array();

			// If blank resultset, then return empty array
			if (!$objDbResult)
				return $objToReturn;

			// Load up the return array with each row
			if ($strExpandAsArrayNodes) {
				$objToReturn = array();
				while ($objDbRow = $objDbResult->GetNextRow()) {
					$objItem = TableUserProfile::InstantiateDbRow($objDbRow, null, $strExpandAsArrayNodes, $objToReturn, $strColumnAliasArray);
					if ($objItem) {
						$objToReturn[] = $objItem;
					}
				}
			} else {
				while ($objDbRow = $objDbResult->GetNextRow())
					$objToReturn[] = TableUserProfile::InstantiateDbRow($objDbRow, null, null, null, $strColumnAliasArray);
			}

			return $objToReturn;
		}



		///////////////////////////////////////////////////
		// INDEX-BASED LOAD METHODS (Single Load and Array)
		///////////////////////////////////////////////////
			
		/**
		 * Load a single TableUserProfile object,
		 * by Id Index(es)
		 * @param integer $intId
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile
		*/
		public static function LoadById($intId, $objOptionalClauses = null) {
			return TableUserProfile::QuerySingle(
				QQ::AndCondition(
					QQ::Equal(QQN::TableUserProfile()->Id, $intId)
				),
				$objOptionalClauses
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by UserId Index(es)
		 * @param integer $intUserId
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByUserId($intUserId, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByUserId query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->UserId, $intUserId),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by UserId Index(es)
		 * @param integer $intUserId
		 * @return int
		*/
		public static function CountByUserId($intUserId) {
			// Call TableUserProfile::QueryCount to perform the CountByUserId query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->UserId, $intUserId)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by CompanyUser Index(es)
		 * @param string $strCompanyUser
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByCompanyUser($strCompanyUser, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByCompanyUser query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->CompanyUser, $strCompanyUser),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by CompanyUser Index(es)
		 * @param string $strCompanyUser
		 * @return int
		*/
		public static function CountByCompanyUser($strCompanyUser) {
			// Call TableUserProfile::QueryCount to perform the CountByCompanyUser query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->CompanyUser, $strCompanyUser)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by CustomerCount Index(es)
		 * @param integer $intCustomerCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByCustomerCount($intCustomerCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByCustomerCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->CustomerCount, $intCustomerCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by CustomerCount Index(es)
		 * @param integer $intCustomerCount
		 * @return int
		*/
		public static function CountByCustomerCount($intCustomerCount) {
			// Call TableUserProfile::QueryCount to perform the CountByCustomerCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->CustomerCount, $intCustomerCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by RepeaterCount Index(es)
		 * @param integer $intRepeaterCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByRepeaterCount($intRepeaterCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByRepeaterCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->RepeaterCount, $intRepeaterCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by RepeaterCount Index(es)
		 * @param integer $intRepeaterCount
		 * @return int
		*/
		public static function CountByRepeaterCount($intRepeaterCount) {
			// Call TableUserProfile::QueryCount to perform the CountByRepeaterCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->RepeaterCount, $intRepeaterCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by WonProjectCount Index(es)
		 * @param integer $intWonProjectCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByWonProjectCount($intWonProjectCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByWonProjectCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->WonProjectCount, $intWonProjectCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by WonProjectCount Index(es)
		 * @param integer $intWonProjectCount
		 * @return int
		*/
		public static function CountByWonProjectCount($intWonProjectCount) {
			// Call TableUserProfile::QueryCount to perform the CountByWonProjectCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->WonProjectCount, $intWonProjectCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by CompletedWonProjectCount Index(es)
		 * @param integer $intCompletedWonProjectCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByCompletedWonProjectCount($intCompletedWonProjectCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByCompletedWonProjectCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->CompletedWonProjectCount, $intCompletedWonProjectCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by CompletedWonProjectCount Index(es)
		 * @param integer $intCompletedWonProjectCount
		 * @return int
		*/
		public static function CountByCompletedWonProjectCount($intCompletedWonProjectCount) {
			// Call TableUserProfile::QueryCount to perform the CountByCompletedWonProjectCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->CompletedWonProjectCount, $intCompletedWonProjectCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by PostProjectCount Index(es)
		 * @param integer $intPostProjectCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByPostProjectCount($intPostProjectCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByPostProjectCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->PostProjectCount, $intPostProjectCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by PostProjectCount Index(es)
		 * @param integer $intPostProjectCount
		 * @return int
		*/
		public static function CountByPostProjectCount($intPostProjectCount) {
			// Call TableUserProfile::QueryCount to perform the CountByPostProjectCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->PostProjectCount, $intPostProjectCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by CompletedPostProjectCount Index(es)
		 * @param integer $intCompletedPostProjectCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByCompletedPostProjectCount($intCompletedPostProjectCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByCompletedPostProjectCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->CompletedPostProjectCount, $intCompletedPostProjectCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by CompletedPostProjectCount Index(es)
		 * @param integer $intCompletedPostProjectCount
		 * @return int
		*/
		public static function CountByCompletedPostProjectCount($intCompletedPostProjectCount) {
			// Call TableUserProfile::QueryCount to perform the CountByCompletedPostProjectCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->CompletedPostProjectCount, $intCompletedPostProjectCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by FailedWonProjectCount Index(es)
		 * @param integer $intFailedWonProjectCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByFailedWonProjectCount($intFailedWonProjectCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByFailedWonProjectCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->FailedWonProjectCount, $intFailedWonProjectCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by FailedWonProjectCount Index(es)
		 * @param integer $intFailedWonProjectCount
		 * @return int
		*/
		public static function CountByFailedWonProjectCount($intFailedWonProjectCount) {
			// Call TableUserProfile::QueryCount to perform the CountByFailedWonProjectCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->FailedWonProjectCount, $intFailedWonProjectCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by FailedPostProjectCount Index(es)
		 * @param integer $intFailedPostProjectCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByFailedPostProjectCount($intFailedPostProjectCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByFailedPostProjectCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->FailedPostProjectCount, $intFailedPostProjectCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by FailedPostProjectCount Index(es)
		 * @param integer $intFailedPostProjectCount
		 * @return int
		*/
		public static function CountByFailedPostProjectCount($intFailedPostProjectCount) {
			// Call TableUserProfile::QueryCount to perform the CountByFailedPostProjectCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->FailedPostProjectCount, $intFailedPostProjectCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by BidProjectCount Index(es)
		 * @param integer $intBidProjectCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByBidProjectCount($intBidProjectCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByBidProjectCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->BidProjectCount, $intBidProjectCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by BidProjectCount Index(es)
		 * @param integer $intBidProjectCount
		 * @return int
		*/
		public static function CountByBidProjectCount($intBidProjectCount) {
			// Call TableUserProfile::QueryCount to perform the CountByBidProjectCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->BidProjectCount, $intBidProjectCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by BidProjectCountThisMonth Index(es)
		 * @param integer $intBidProjectCountThisMonth
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByBidProjectCountThisMonth($intBidProjectCountThisMonth, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByBidProjectCountThisMonth query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->BidProjectCountThisMonth, $intBidProjectCountThisMonth),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by BidProjectCountThisMonth Index(es)
		 * @param integer $intBidProjectCountThisMonth
		 * @return int
		*/
		public static function CountByBidProjectCountThisMonth($intBidProjectCountThisMonth) {
			// Call TableUserProfile::QueryCount to perform the CountByBidProjectCountThisMonth query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->BidProjectCountThisMonth, $intBidProjectCountThisMonth)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by WonProjectReviewCount Index(es)
		 * @param integer $intWonProjectReviewCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByWonProjectReviewCount($intWonProjectReviewCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByWonProjectReviewCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->WonProjectReviewCount, $intWonProjectReviewCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by WonProjectReviewCount Index(es)
		 * @param integer $intWonProjectReviewCount
		 * @return int
		*/
		public static function CountByWonProjectReviewCount($intWonProjectReviewCount) {
			// Call TableUserProfile::QueryCount to perform the CountByWonProjectReviewCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->WonProjectReviewCount, $intWonProjectReviewCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by WonProjectPositiveReviewCount Index(es)
		 * @param integer $intWonProjectPositiveReviewCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByWonProjectPositiveReviewCount($intWonProjectPositiveReviewCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByWonProjectPositiveReviewCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->WonProjectPositiveReviewCount, $intWonProjectPositiveReviewCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by WonProjectPositiveReviewCount Index(es)
		 * @param integer $intWonProjectPositiveReviewCount
		 * @return int
		*/
		public static function CountByWonProjectPositiveReviewCount($intWonProjectPositiveReviewCount) {
			// Call TableUserProfile::QueryCount to perform the CountByWonProjectPositiveReviewCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->WonProjectPositiveReviewCount, $intWonProjectPositiveReviewCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by WonProjectNeutralReviewCount Index(es)
		 * @param integer $intWonProjectNeutralReviewCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByWonProjectNeutralReviewCount($intWonProjectNeutralReviewCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByWonProjectNeutralReviewCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->WonProjectNeutralReviewCount, $intWonProjectNeutralReviewCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by WonProjectNeutralReviewCount Index(es)
		 * @param integer $intWonProjectNeutralReviewCount
		 * @return int
		*/
		public static function CountByWonProjectNeutralReviewCount($intWonProjectNeutralReviewCount) {
			// Call TableUserProfile::QueryCount to perform the CountByWonProjectNeutralReviewCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->WonProjectNeutralReviewCount, $intWonProjectNeutralReviewCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by WonProjectNegativeReviewCount Index(es)
		 * @param integer $intWonProjectNegativeReviewCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByWonProjectNegativeReviewCount($intWonProjectNegativeReviewCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByWonProjectNegativeReviewCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->WonProjectNegativeReviewCount, $intWonProjectNegativeReviewCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by WonProjectNegativeReviewCount Index(es)
		 * @param integer $intWonProjectNegativeReviewCount
		 * @return int
		*/
		public static function CountByWonProjectNegativeReviewCount($intWonProjectNegativeReviewCount) {
			// Call TableUserProfile::QueryCount to perform the CountByWonProjectNegativeReviewCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->WonProjectNegativeReviewCount, $intWonProjectNegativeReviewCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by PostProjectReviewCount Index(es)
		 * @param integer $intPostProjectReviewCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByPostProjectReviewCount($intPostProjectReviewCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByPostProjectReviewCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->PostProjectReviewCount, $intPostProjectReviewCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by PostProjectReviewCount Index(es)
		 * @param integer $intPostProjectReviewCount
		 * @return int
		*/
		public static function CountByPostProjectReviewCount($intPostProjectReviewCount) {
			// Call TableUserProfile::QueryCount to perform the CountByPostProjectReviewCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->PostProjectReviewCount, $intPostProjectReviewCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by PostProjectPositiveReviewCount Index(es)
		 * @param integer $intPostProjectPositiveReviewCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByPostProjectPositiveReviewCount($intPostProjectPositiveReviewCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByPostProjectPositiveReviewCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->PostProjectPositiveReviewCount, $intPostProjectPositiveReviewCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by PostProjectPositiveReviewCount Index(es)
		 * @param integer $intPostProjectPositiveReviewCount
		 * @return int
		*/
		public static function CountByPostProjectPositiveReviewCount($intPostProjectPositiveReviewCount) {
			// Call TableUserProfile::QueryCount to perform the CountByPostProjectPositiveReviewCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->PostProjectPositiveReviewCount, $intPostProjectPositiveReviewCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by PostProjectNeutralReviewCount Index(es)
		 * @param integer $intPostProjectNeutralReviewCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByPostProjectNeutralReviewCount($intPostProjectNeutralReviewCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByPostProjectNeutralReviewCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->PostProjectNeutralReviewCount, $intPostProjectNeutralReviewCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by PostProjectNeutralReviewCount Index(es)
		 * @param integer $intPostProjectNeutralReviewCount
		 * @return int
		*/
		public static function CountByPostProjectNeutralReviewCount($intPostProjectNeutralReviewCount) {
			// Call TableUserProfile::QueryCount to perform the CountByPostProjectNeutralReviewCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->PostProjectNeutralReviewCount, $intPostProjectNeutralReviewCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by PostProjectNegativeReviewCount Index(es)
		 * @param integer $intPostProjectNegativeReviewCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByPostProjectNegativeReviewCount($intPostProjectNegativeReviewCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByPostProjectNegativeReviewCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->PostProjectNegativeReviewCount, $intPostProjectNegativeReviewCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by PostProjectNegativeReviewCount Index(es)
		 * @param integer $intPostProjectNegativeReviewCount
		 * @return int
		*/
		public static function CountByPostProjectNegativeReviewCount($intPostProjectNegativeReviewCount) {
			// Call TableUserProfile::QueryCount to perform the CountByPostProjectNegativeReviewCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->PostProjectNegativeReviewCount, $intPostProjectNegativeReviewCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by SuspendCount Index(es)
		 * @param integer $intSuspendCount
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayBySuspendCount($intSuspendCount, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayBySuspendCount query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->SuspendCount, $intSuspendCount),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by SuspendCount Index(es)
		 * @param integer $intSuspendCount
		 * @return int
		*/
		public static function CountBySuspendCount($intSuspendCount) {
			// Call TableUserProfile::QueryCount to perform the CountBySuspendCount query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->SuspendCount, $intSuspendCount)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by PaypalEmail Index(es)
		 * @param string $strPaypalEmail
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByPaypalEmail($strPaypalEmail, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByPaypalEmail query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->PaypalEmail, $strPaypalEmail),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by PaypalEmail Index(es)
		 * @param string $strPaypalEmail
		 * @return int
		*/
		public static function CountByPaypalEmail($strPaypalEmail) {
			// Call TableUserProfile::QueryCount to perform the CountByPaypalEmail query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->PaypalEmail, $strPaypalEmail)
			);
		}
			
		/**
		 * Load an array of TableUserProfile objects,
		 * by UpdateDate Index(es)
		 * @param QDateTime $dttUpdateDate
		 * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
		 * @return TableUserProfile[]
		*/
		public static function LoadArrayByUpdateDate($dttUpdateDate, $objOptionalClauses = null) {
			// Call TableUserProfile::QueryArray to perform the LoadArrayByUpdateDate query
			try {
				return TableUserProfile::QueryArray(
					QQ::Equal(QQN::TableUserProfile()->UpdateDate, $dttUpdateDate),
					$objOptionalClauses);
			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}
		}

		/**
		 * Count TableUserProfiles
		 * by UpdateDate Index(es)
		 * @param QDateTime $dttUpdateDate
		 * @return int
		*/
		public static function CountByUpdateDate($dttUpdateDate) {
			// Call TableUserProfile::QueryCount to perform the CountByUpdateDate query
			return TableUserProfile::QueryCount(
				QQ::Equal(QQN::TableUserProfile()->UpdateDate, $dttUpdateDate)
			);
		}



		////////////////////////////////////////////////////
		// INDEX-BASED LOAD METHODS (Array via Many to Many)
		////////////////////////////////////////////////////




		//////////////////////////
		// SAVE, DELETE AND RELOAD
		//////////////////////////

		/**
		 * Save this TableUserProfile
		 * @param bool $blnForceInsert
		 * @param bool $blnForceUpdate
		 * @return int
		 */
		public function Save($blnForceInsert = false, $blnForceUpdate = false) {
			// Get the Database Object for this Class
			$objDatabase = TableUserProfile::GetDatabase();

			$mixToReturn = null;

			try {
				if ((!$this->__blnRestored) || ($blnForceInsert)) {
					// Perform an INSERT query
					$objDatabase->NonQuery('
						INSERT INTO `table_user_profile` (
							`user_id`,
							`company_user`,
							`catch_phrase`,
							`language_description`,
							`keyword_description`,
							`message`,
							`location`,
							`customer_count`,
							`repeater_count`,
							`won_project_count`,
							`completed_won_project_count`,
							`failed_won_project_count`,
							`post_project_count`,
							`completed_post_project_count`,
							`failed_post_project_count`,
							`bid_project_count`,
							`bid_project_count_this_month`,
							`won_project_review_count`,
							`won_project_positive_review_count`,
							`won_project_neutral_review_count`,
							`won_project_negative_review_count`,
							`post_project_review_count`,
							`post_project_positive_review_count`,
							`post_project_neutral_review_count`,
							`post_project_negative_review_count`,
							`suspend_count`,
							`paypal_email`,
							`limited_ip`,
							`update_date`,
							`vision`,
							`area_of_expertise`,
							`completion_ratio`,
							`budget_paid_ratio`,
							`pagination_number`,
							`landing_page`
						) VALUES (
							' . $objDatabase->SqlVariable($this->intUserId) . ',
							' . $objDatabase->SqlVariable($this->strCompanyUser) . ',
							' . $objDatabase->SqlVariable($this->strCatchPhrase) . ',
							' . $objDatabase->SqlVariable($this->strLanguageDescription) . ',
							' . $objDatabase->SqlVariable($this->strKeywordDescription) . ',
							' . $objDatabase->SqlVariable($this->strMessage) . ',
							' . $objDatabase->SqlVariable($this->strLocation) . ',
							' . $objDatabase->SqlVariable($this->intCustomerCount) . ',
							' . $objDatabase->SqlVariable($this->intRepeaterCount) . ',
							' . $objDatabase->SqlVariable($this->intWonProjectCount) . ',
							' . $objDatabase->SqlVariable($this->intCompletedWonProjectCount) . ',
							' . $objDatabase->SqlVariable($this->intFailedWonProjectCount) . ',
							' . $objDatabase->SqlVariable($this->intPostProjectCount) . ',
							' . $objDatabase->SqlVariable($this->intCompletedPostProjectCount) . ',
							' . $objDatabase->SqlVariable($this->intFailedPostProjectCount) . ',
							' . $objDatabase->SqlVariable($this->intBidProjectCount) . ',
							' . $objDatabase->SqlVariable($this->intBidProjectCountThisMonth) . ',
							' . $objDatabase->SqlVariable($this->intWonProjectReviewCount) . ',
							' . $objDatabase->SqlVariable($this->intWonProjectPositiveReviewCount) . ',
							' . $objDatabase->SqlVariable($this->intWonProjectNeutralReviewCount) . ',
							' . $objDatabase->SqlVariable($this->intWonProjectNegativeReviewCount) . ',
							' . $objDatabase->SqlVariable($this->intPostProjectReviewCount) . ',
							' . $objDatabase->SqlVariable($this->intPostProjectPositiveReviewCount) . ',
							' . $objDatabase->SqlVariable($this->intPostProjectNeutralReviewCount) . ',
							' . $objDatabase->SqlVariable($this->intPostProjectNegativeReviewCount) . ',
							' . $objDatabase->SqlVariable($this->intSuspendCount) . ',
							' . $objDatabase->SqlVariable($this->strPaypalEmail) . ',
							' . $objDatabase->SqlVariable($this->strLimitedIp) . ',
							' . $objDatabase->SqlVariable($this->dttUpdateDate) . ',
							' . $objDatabase->SqlVariable($this->strVision) . ',
							' . $objDatabase->SqlVariable($this->strAreaOfExpertise) . ',
							' . $objDatabase->SqlVariable($this->fltCompletionRatio) . ',
							' . $objDatabase->SqlVariable($this->fltBudgetPaidRatio) . ',
							' . $objDatabase->SqlVariable($this->intPaginationNumber) . ',
							' . $objDatabase->SqlVariable($this->intLandingPage) . '
						)
					');

					// Update Identity column and return its value
					$mixToReturn = $this->intId = $objDatabase->InsertId('table_user_profile', 'id');
				} else {
					// Perform an UPDATE query

					// First checking for Optimistic Locking constraints (if applicable)

					// Perform the UPDATE query
					$objDatabase->NonQuery('
						UPDATE
							`table_user_profile`
						SET
							`user_id` = ' . $objDatabase->SqlVariable($this->intUserId) . ',
							`company_user` = ' . $objDatabase->SqlVariable($this->strCompanyUser) . ',
							`catch_phrase` = ' . $objDatabase->SqlVariable($this->strCatchPhrase) . ',
							`language_description` = ' . $objDatabase->SqlVariable($this->strLanguageDescription) . ',
							`keyword_description` = ' . $objDatabase->SqlVariable($this->strKeywordDescription) . ',
							`message` = ' . $objDatabase->SqlVariable($this->strMessage) . ',
							`location` = ' . $objDatabase->SqlVariable($this->strLocation) . ',
							`customer_count` = ' . $objDatabase->SqlVariable($this->intCustomerCount) . ',
							`repeater_count` = ' . $objDatabase->SqlVariable($this->intRepeaterCount) . ',
							`won_project_count` = ' . $objDatabase->SqlVariable($this->intWonProjectCount) . ',
							`completed_won_project_count` = ' . $objDatabase->SqlVariable($this->intCompletedWonProjectCount) . ',
							`failed_won_project_count` = ' . $objDatabase->SqlVariable($this->intFailedWonProjectCount) . ',
							`post_project_count` = ' . $objDatabase->SqlVariable($this->intPostProjectCount) . ',
							`completed_post_project_count` = ' . $objDatabase->SqlVariable($this->intCompletedPostProjectCount) . ',
							`failed_post_project_count` = ' . $objDatabase->SqlVariable($this->intFailedPostProjectCount) . ',
							`bid_project_count` = ' . $objDatabase->SqlVariable($this->intBidProjectCount) . ',
							`bid_project_count_this_month` = ' . $objDatabase->SqlVariable($this->intBidProjectCountThisMonth) . ',
							`won_project_review_count` = ' . $objDatabase->SqlVariable($this->intWonProjectReviewCount) . ',
							`won_project_positive_review_count` = ' . $objDatabase->SqlVariable($this->intWonProjectPositiveReviewCount) . ',
							`won_project_neutral_review_count` = ' . $objDatabase->SqlVariable($this->intWonProjectNeutralReviewCount) . ',
							`won_project_negative_review_count` = ' . $objDatabase->SqlVariable($this->intWonProjectNegativeReviewCount) . ',
							`post_project_review_count` = ' . $objDatabase->SqlVariable($this->intPostProjectReviewCount) . ',
							`post_project_positive_review_count` = ' . $objDatabase->SqlVariable($this->intPostProjectPositiveReviewCount) . ',
							`post_project_neutral_review_count` = ' . $objDatabase->SqlVariable($this->intPostProjectNeutralReviewCount) . ',
							`post_project_negative_review_count` = ' . $objDatabase->SqlVariable($this->intPostProjectNegativeReviewCount) . ',
							`suspend_count` = ' . $objDatabase->SqlVariable($this->intSuspendCount) . ',
							`paypal_email` = ' . $objDatabase->SqlVariable($this->strPaypalEmail) . ',
							`limited_ip` = ' . $objDatabase->SqlVariable($this->strLimitedIp) . ',
							`update_date` = ' . $objDatabase->SqlVariable($this->dttUpdateDate) . ',
							`vision` = ' . $objDatabase->SqlVariable($this->strVision) . ',
							`area_of_expertise` = ' . $objDatabase->SqlVariable($this->strAreaOfExpertise) . ',
							`completion_ratio` = ' . $objDatabase->SqlVariable($this->fltCompletionRatio) . ',
							`budget_paid_ratio` = ' . $objDatabase->SqlVariable($this->fltBudgetPaidRatio) . ',
							`pagination_number` = ' . $objDatabase->SqlVariable($this->intPaginationNumber) . ',
							`landing_page` = ' . $objDatabase->SqlVariable($this->intLandingPage) . '
						WHERE
							`id` = ' . $objDatabase->SqlVariable($this->intId) . '
					');
				}

			} catch (QCallerException $objExc) {
				$objExc->IncrementOffset();
				throw $objExc;
			}

			// Update __blnRestored and any Non-Identity PK Columns (if applicable)
			$this->__blnRestored = true;


			// Return 
			return $mixToReturn;
		}

		/**
		 * Delete this TableUserProfile
		 * @return void
		 */
		public function Delete() {
			if ((is_null($this->intId)))
				throw new QUndefinedPrimaryKeyException('Cannot delete this TableUserProfile with an unset primary key.');

			// Get the Database Object for this Class
			$objDatabase = TableUserProfile::GetDatabase();


			// Perform the SQL Query
			$objDatabase->NonQuery('
				DELETE FROM
					`table_user_profile`
				WHERE
					`id` = ' . $objDatabase->SqlVariable($this->intId) . '');
		}

		/**
		 * Delete all TableUserProfiles
		 * @return void
		 */
		public static function DeleteAll() {
			// Get the Database Object for this Class
			$objDatabase = TableUserProfile::GetDatabase();

			// Perform the Query
			$objDatabase->NonQuery('
				DELETE FROM
					`table_user_profile`');
		}

		/**
		 * Truncate table_user_profile table
		 * @return void
		 */
		public static function Truncate() {
			// Get the Database Object for this Class
			$objDatabase = TableUserProfile::GetDatabase();

			// Perform the Query
			$objDatabase->NonQuery('
				TRUNCATE `table_user_profile`');
		}

		/**
		 * Reload this TableUserProfile from the database.
		 * @return void
		 */
		public function Reload() {
			// Make sure we are actually Restored from the database
			if (!$this->__blnRestored)
				throw new QCallerException('Cannot call Reload() on a new, unsaved TableUserProfile object.');

			// Reload the Object
			$objReloaded = TableUserProfile::Load($this->intId);

			// Update $this's local variables to match
			$this->UserId = $objReloaded->UserId;
			$this->strCompanyUser = $objReloaded->strCompanyUser;
			$this->strCatchPhrase = $objReloaded->strCatchPhrase;
			$this->strLanguageDescription = $objReloaded->strLanguageDescription;
			$this->strKeywordDescription = $objReloaded->strKeywordDescription;
			$this->strMessage = $objReloaded->strMessage;
			$this->strLocation = $objReloaded->strLocation;
			$this->intCustomerCount = $objReloaded->intCustomerCount;
			$this->intRepeaterCount = $objReloaded->intRepeaterCount;
			$this->intWonProjectCount = $objReloaded->intWonProjectCount;
			$this->intCompletedWonProjectCount = $objReloaded->intCompletedWonProjectCount;
			$this->intFailedWonProjectCount = $objReloaded->intFailedWonProjectCount;
			$this->intPostProjectCount = $objReloaded->intPostProjectCount;
			$this->intCompletedPostProjectCount = $objReloaded->intCompletedPostProjectCount;
			$this->intFailedPostProjectCount = $objReloaded->intFailedPostProjectCount;
			$this->intBidProjectCount = $objReloaded->intBidProjectCount;
			$this->intBidProjectCountThisMonth = $objReloaded->intBidProjectCountThisMonth;
			$this->intWonProjectReviewCount = $objReloaded->intWonProjectReviewCount;
			$this->intWonProjectPositiveReviewCount = $objReloaded->intWonProjectPositiveReviewCount;
			$this->intWonProjectNeutralReviewCount = $objReloaded->intWonProjectNeutralReviewCount;
			$this->intWonProjectNegativeReviewCount = $objReloaded->intWonProjectNegativeReviewCount;
			$this->intPostProjectReviewCount = $objReloaded->intPostProjectReviewCount;
			$this->intPostProjectPositiveReviewCount = $objReloaded->intPostProjectPositiveReviewCount;
			$this->intPostProjectNeutralReviewCount = $objReloaded->intPostProjectNeutralReviewCount;
			$this->intPostProjectNegativeReviewCount = $objReloaded->intPostProjectNegativeReviewCount;
			$this->intSuspendCount = $objReloaded->intSuspendCount;
			$this->strPaypalEmail = $objReloaded->strPaypalEmail;
			$this->strLimitedIp = $objReloaded->strLimitedIp;
			$this->dttUpdateDate = $objReloaded->dttUpdateDate;
			$this->strVision = $objReloaded->strVision;
			$this->strAreaOfExpertise = $objReloaded->strAreaOfExpertise;
			$this->fltCompletionRatio = $objReloaded->fltCompletionRatio;
			$this->fltBudgetPaidRatio = $objReloaded->fltBudgetPaidRatio;
			$this->intPaginationNumber = $objReloaded->intPaginationNumber;
			$this->intLandingPage = $objReloaded->intLandingPage;
		}



		////////////////////
		// PUBLIC OVERRIDERS
		////////////////////

				/**
		 * Override method to perform a property "Get"
		 * This will get the value of $strName
		 *
		 * @param string $strName Name of the property to get
		 * @return mixed
		 */
		public function __get($strName) {
			switch ($strName) {
				///////////////////
				// Member Variables
				///////////////////
				case 'Id':
					/**
					 * Gets the value for intId (Read-Only PK)
					 * @return integer
					 */
					return $this->intId;

				case 'UserId':
					/**
					 * Gets the value for intUserId (Not Null)
					 * @return integer
					 */
					return $this->intUserId;

				case 'CompanyUser':
					/**
					 * Gets the value for strCompanyUser (Not Null)
					 * @return string
					 */
					return $this->strCompanyUser;

				case 'CatchPhrase':
					/**
					 * Gets the value for strCatchPhrase 
					 * @return string
					 */
					return $this->strCatchPhrase;

				case 'LanguageDescription':
					/**
					 * Gets the value for strLanguageDescription 
					 * @return string
					 */
					return $this->strLanguageDescription;

				case 'KeywordDescription':
					/**
					 * Gets the value for strKeywordDescription 
					 * @return string
					 */
					return $this->strKeywordDescription;

				case 'Message':
					/**
					 * Gets the value for strMessage 
					 * @return string
					 */
					return $this->strMessage;

				case 'Location':
					/**
					 * Gets the value for strLocation 
					 * @return string
					 */
					return $this->strLocation;

				case 'CustomerCount':
					/**
					 * Gets the value for intCustomerCount (Not Null)
					 * @return integer
					 */
					return $this->intCustomerCount;

				case 'RepeaterCount':
					/**
					 * Gets the value for intRepeaterCount (Not Null)
					 * @return integer
					 */
					return $this->intRepeaterCount;

				case 'WonProjectCount':
					/**
					 * Gets the value for intWonProjectCount (Not Null)
					 * @return integer
					 */
					return $this->intWonProjectCount;

				case 'CompletedWonProjectCount':
					/**
					 * Gets the value for intCompletedWonProjectCount (Not Null)
					 * @return integer
					 */
					return $this->intCompletedWonProjectCount;

				case 'FailedWonProjectCount':
					/**
					 * Gets the value for intFailedWonProjectCount (Not Null)
					 * @return integer
					 */
					return $this->intFailedWonProjectCount;

				case 'PostProjectCount':
					/**
					 * Gets the value for intPostProjectCount (Not Null)
					 * @return integer
					 */
					return $this->intPostProjectCount;

				case 'CompletedPostProjectCount':
					/**
					 * Gets the value for intCompletedPostProjectCount (Not Null)
					 * @return integer
					 */
					return $this->intCompletedPostProjectCount;

				case 'FailedPostProjectCount':
					/**
					 * Gets the value for intFailedPostProjectCount (Not Null)
					 * @return integer
					 */
					return $this->intFailedPostProjectCount;

				case 'BidProjectCount':
					/**
					 * Gets the value for intBidProjectCount (Not Null)
					 * @return integer
					 */
					return $this->intBidProjectCount;

				case 'BidProjectCountThisMonth':
					/**
					 * Gets the value for intBidProjectCountThisMonth (Not Null)
					 * @return integer
					 */
					return $this->intBidProjectCountThisMonth;

				case 'WonProjectReviewCount':
					/**
					 * Gets the value for intWonProjectReviewCount (Not Null)
					 * @return integer
					 */
					return $this->intWonProjectReviewCount;

				case 'WonProjectPositiveReviewCount':
					/**
					 * Gets the value for intWonProjectPositiveReviewCount (Not Null)
					 * @return integer
					 */
					return $this->intWonProjectPositiveReviewCount;

				case 'WonProjectNeutralReviewCount':
					/**
					 * Gets the value for intWonProjectNeutralReviewCount (Not Null)
					 * @return integer
					 */
					return $this->intWonProjectNeutralReviewCount;

				case 'WonProjectNegativeReviewCount':
					/**
					 * Gets the value for intWonProjectNegativeReviewCount (Not Null)
					 * @return integer
					 */
					return $this->intWonProjectNegativeReviewCount;

				case 'PostProjectReviewCount':
					/**
					 * Gets the value for intPostProjectReviewCount (Not Null)
					 * @return integer
					 */
					return $this->intPostProjectReviewCount;

				case 'PostProjectPositiveReviewCount':
					/**
					 * Gets the value for intPostProjectPositiveReviewCount (Not Null)
					 * @return integer
					 */
					return $this->intPostProjectPositiveReviewCount;

				case 'PostProjectNeutralReviewCount':
					/**
					 * Gets the value for intPostProjectNeutralReviewCount (Not Null)
					 * @return integer
					 */
					return $this->intPostProjectNeutralReviewCount;

				case 'PostProjectNegativeReviewCount':
					/**
					 * Gets the value for intPostProjectNegativeReviewCount (Not Null)
					 * @return integer
					 */
					return $this->intPostProjectNegativeReviewCount;

				case 'SuspendCount':
					/**
					 * Gets the value for intSuspendCount (Not Null)
					 * @return integer
					 */
					return $this->intSuspendCount;

				case 'PaypalEmail':
					/**
					 * Gets the value for strPaypalEmail (Not Null)
					 * @return string
					 */
					return $this->strPaypalEmail;

				case 'LimitedIp':
					/**
					 * Gets the value for strLimitedIp 
					 * @return string
					 */
					return $this->strLimitedIp;

				case 'UpdateDate':
					/**
					 * Gets the value for dttUpdateDate 
					 * @return QDateTime
					 */
					return $this->dttUpdateDate;

				case 'Vision':
					/**
					 * Gets the value for strVision 
					 * @return string
					 */
					return $this->strVision;

				case 'AreaOfExpertise':
					/**
					 * Gets the value for strAreaOfExpertise 
					 * @return string
					 */
					return $this->strAreaOfExpertise;

				case 'CompletionRatio':
					/**
					 * Gets the value for fltCompletionRatio (Not Null)
					 * @return double
					 */
					return $this->fltCompletionRatio;

				case 'BudgetPaidRatio':
					/**
					 * Gets the value for fltBudgetPaidRatio (Not Null)
					 * @return double
					 */
					return $this->fltBudgetPaidRatio;

				case 'PaginationNumber':
					/**
					 * Gets the value for intPaginationNumber (Not Null)
					 * @return integer
					 */
					return $this->intPaginationNumber;

				case 'LandingPage':
					/**
					 * Gets the value for intLandingPage 
					 * @return integer
					 */
					return $this->intLandingPage;


				///////////////////
				// Member Objects
				///////////////////
				case 'User':
					/**
					 * Gets the value for the TableUserProject object referenced by intUserId (Not Null)
					 * @return TableUserProject
					 */
					try {
						if ((!$this->objUser) && (!is_null($this->intUserId)))
							$this->objUser = TableUserProject::Load($this->intUserId);
						return $this->objUser;
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}


				////////////////////////////
				// Virtual Object References (Many to Many and Reverse References)
				// (If restored via a "Many-to" expansion)
				////////////////////////////


				case '__Restored':
					return $this->__blnRestored;

				default:
					try {
						return parent::__get($strName);
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}
			}
		}

				/**
		 * Override method to perform a property "Set"
		 * This will set the property $strName to be $mixValue
		 *
		 * @param string $strName Name of the property to set
		 * @param string $mixValue New value of the property
		 * @return mixed
		 */
		public function __set($strName, $mixValue) {
			switch ($strName) {
				///////////////////
				// Member Variables
				///////////////////
				case 'UserId':
					/**
					 * Sets the value for intUserId (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						$this->objUser = null;
						return ($this->intUserId = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'CompanyUser':
					/**
					 * Sets the value for strCompanyUser (Not Null)
					 * @param string $mixValue
					 * @return string
					 */
					try {
						return ($this->strCompanyUser = QType::Cast($mixValue, QType::String));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'CatchPhrase':
					/**
					 * Sets the value for strCatchPhrase 
					 * @param string $mixValue
					 * @return string
					 */
					try {
						return ($this->strCatchPhrase = QType::Cast($mixValue, QType::String));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'LanguageDescription':
					/**
					 * Sets the value for strLanguageDescription 
					 * @param string $mixValue
					 * @return string
					 */
					try {
						return ($this->strLanguageDescription = QType::Cast($mixValue, QType::String));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'KeywordDescription':
					/**
					 * Sets the value for strKeywordDescription 
					 * @param string $mixValue
					 * @return string
					 */
					try {
						return ($this->strKeywordDescription = QType::Cast($mixValue, QType::String));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'Message':
					/**
					 * Sets the value for strMessage 
					 * @param string $mixValue
					 * @return string
					 */
					try {
						return ($this->strMessage = QType::Cast($mixValue, QType::String));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'Location':
					/**
					 * Sets the value for strLocation 
					 * @param string $mixValue
					 * @return string
					 */
					try {
						return ($this->strLocation = QType::Cast($mixValue, QType::String));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'CustomerCount':
					/**
					 * Sets the value for intCustomerCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intCustomerCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'RepeaterCount':
					/**
					 * Sets the value for intRepeaterCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intRepeaterCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'WonProjectCount':
					/**
					 * Sets the value for intWonProjectCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intWonProjectCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'CompletedWonProjectCount':
					/**
					 * Sets the value for intCompletedWonProjectCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intCompletedWonProjectCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'FailedWonProjectCount':
					/**
					 * Sets the value for intFailedWonProjectCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intFailedWonProjectCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'PostProjectCount':
					/**
					 * Sets the value for intPostProjectCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intPostProjectCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'CompletedPostProjectCount':
					/**
					 * Sets the value for intCompletedPostProjectCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intCompletedPostProjectCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'FailedPostProjectCount':
					/**
					 * Sets the value for intFailedPostProjectCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intFailedPostProjectCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'BidProjectCount':
					/**
					 * Sets the value for intBidProjectCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intBidProjectCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'BidProjectCountThisMonth':
					/**
					 * Sets the value for intBidProjectCountThisMonth (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intBidProjectCountThisMonth = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'WonProjectReviewCount':
					/**
					 * Sets the value for intWonProjectReviewCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intWonProjectReviewCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'WonProjectPositiveReviewCount':
					/**
					 * Sets the value for intWonProjectPositiveReviewCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intWonProjectPositiveReviewCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'WonProjectNeutralReviewCount':
					/**
					 * Sets the value for intWonProjectNeutralReviewCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intWonProjectNeutralReviewCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'WonProjectNegativeReviewCount':
					/**
					 * Sets the value for intWonProjectNegativeReviewCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intWonProjectNegativeReviewCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'PostProjectReviewCount':
					/**
					 * Sets the value for intPostProjectReviewCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intPostProjectReviewCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'PostProjectPositiveReviewCount':
					/**
					 * Sets the value for intPostProjectPositiveReviewCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intPostProjectPositiveReviewCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'PostProjectNeutralReviewCount':
					/**
					 * Sets the value for intPostProjectNeutralReviewCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intPostProjectNeutralReviewCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'PostProjectNegativeReviewCount':
					/**
					 * Sets the value for intPostProjectNegativeReviewCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intPostProjectNegativeReviewCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'SuspendCount':
					/**
					 * Sets the value for intSuspendCount (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intSuspendCount = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'PaypalEmail':
					/**
					 * Sets the value for strPaypalEmail (Not Null)
					 * @param string $mixValue
					 * @return string
					 */
					try {
						return ($this->strPaypalEmail = QType::Cast($mixValue, QType::String));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'LimitedIp':
					/**
					 * Sets the value for strLimitedIp 
					 * @param string $mixValue
					 * @return string
					 */
					try {
						return ($this->strLimitedIp = QType::Cast($mixValue, QType::String));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'UpdateDate':
					/**
					 * Sets the value for dttUpdateDate 
					 * @param QDateTime $mixValue
					 * @return QDateTime
					 */
					try {
						return ($this->dttUpdateDate = QType::Cast($mixValue, QType::DateTime));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'Vision':
					/**
					 * Sets the value for strVision 
					 * @param string $mixValue
					 * @return string
					 */
					try {
						return ($this->strVision = QType::Cast($mixValue, QType::String));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'AreaOfExpertise':
					/**
					 * Sets the value for strAreaOfExpertise 
					 * @param string $mixValue
					 * @return string
					 */
					try {
						return ($this->strAreaOfExpertise = QType::Cast($mixValue, QType::String));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'CompletionRatio':
					/**
					 * Sets the value for fltCompletionRatio (Not Null)
					 * @param double $mixValue
					 * @return double
					 */
					try {
						return ($this->fltCompletionRatio = QType::Cast($mixValue, QType::Float));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'BudgetPaidRatio':
					/**
					 * Sets the value for fltBudgetPaidRatio (Not Null)
					 * @param double $mixValue
					 * @return double
					 */
					try {
						return ($this->fltBudgetPaidRatio = QType::Cast($mixValue, QType::Float));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'PaginationNumber':
					/**
					 * Sets the value for intPaginationNumber (Not Null)
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intPaginationNumber = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}

				case 'LandingPage':
					/**
					 * Sets the value for intLandingPage 
					 * @param integer $mixValue
					 * @return integer
					 */
					try {
						return ($this->intLandingPage = QType::Cast($mixValue, QType::Integer));
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}


				///////////////////
				// Member Objects
				///////////////////
				case 'User':
					/**
					 * Sets the value for the TableUserProject object referenced by intUserId (Not Null)
					 * @param TableUserProject $mixValue
					 * @return TableUserProject
					 */
					if (is_null($mixValue)) {
						$this->intUserId = null;
						$this->objUser = null;
						return null;
					} else {
						// Make sure $mixValue actually is a TableUserProject object
						try {
							$mixValue = QType::Cast($mixValue, 'TableUserProject');
						} catch (QInvalidCastException $objExc) {
							$objExc->IncrementOffset();
							throw $objExc;
						} 

						// Make sure $mixValue is a SAVED TableUserProject object
						if (is_null($mixValue->Id))
							throw new QCallerException('Unable to set an unsaved User for this TableUserProfile');

						// Update Local Member Variables
						$this->objUser = $mixValue;
						$this->intUserId = $mixValue->Id;

						// Return $mixValue
						return $mixValue;
					}
					break;

				default:
					try {
						return parent::__set($strName, $mixValue);
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}
			}
		}

		/**
		 * Lookup a VirtualAttribute value (if applicable).  Returns NULL if none found.
		 * @param string $strName
		 * @return string
		 */
		public function GetVirtualAttribute($strName) {
			if (array_key_exists($strName, $this->__strVirtualAttributeArray))
				return $this->__strVirtualAttributeArray[$strName];
			return null;
		}



		///////////////////////////////
		// ASSOCIATED OBJECTS' METHODS
		///////////////////////////////





		////////////////////////////////////////
		// METHODS for SOAP-BASED WEB SERVICES
		////////////////////////////////////////

		public static function GetSoapComplexTypeXml() {
			$strToReturn = '<complexType name="TableUserProfile"><sequence>';
			$strToReturn .= '<element name="Id" type="xsd:int"/>';
			$strToReturn .= '<element name="User" type="xsd1:TableUserProject"/>';
			$strToReturn .= '<element name="CompanyUser" type="xsd:string"/>';
			$strToReturn .= '<element name="CatchPhrase" type="xsd:string"/>';
			$strToReturn .= '<element name="LanguageDescription" type="xsd:string"/>';
			$strToReturn .= '<element name="KeywordDescription" type="xsd:string"/>';
			$strToReturn .= '<element name="Message" type="xsd:string"/>';
			$strToReturn .= '<element name="Location" type="xsd:string"/>';
			$strToReturn .= '<element name="CustomerCount" type="xsd:int"/>';
			$strToReturn .= '<element name="RepeaterCount" type="xsd:int"/>';
			$strToReturn .= '<element name="WonProjectCount" type="xsd:int"/>';
			$strToReturn .= '<element name="CompletedWonProjectCount" type="xsd:int"/>';
			$strToReturn .= '<element name="FailedWonProjectCount" type="xsd:int"/>';
			$strToReturn .= '<element name="PostProjectCount" type="xsd:int"/>';
			$strToReturn .= '<element name="CompletedPostProjectCount" type="xsd:int"/>';
			$strToReturn .= '<element name="FailedPostProjectCount" type="xsd:int"/>';
			$strToReturn .= '<element name="BidProjectCount" type="xsd:int"/>';
			$strToReturn .= '<element name="BidProjectCountThisMonth" type="xsd:int"/>';
			$strToReturn .= '<element name="WonProjectReviewCount" type="xsd:int"/>';
			$strToReturn .= '<element name="WonProjectPositiveReviewCount" type="xsd:int"/>';
			$strToReturn .= '<element name="WonProjectNeutralReviewCount" type="xsd:int"/>';
			$strToReturn .= '<element name="WonProjectNegativeReviewCount" type="xsd:int"/>';
			$strToReturn .= '<element name="PostProjectReviewCount" type="xsd:int"/>';
			$strToReturn .= '<element name="PostProjectPositiveReviewCount" type="xsd:int"/>';
			$strToReturn .= '<element name="PostProjectNeutralReviewCount" type="xsd:int"/>';
			$strToReturn .= '<element name="PostProjectNegativeReviewCount" type="xsd:int"/>';
			$strToReturn .= '<element name="SuspendCount" type="xsd:int"/>';
			$strToReturn .= '<element name="PaypalEmail" type="xsd:string"/>';
			$strToReturn .= '<element name="LimitedIp" type="xsd:string"/>';
			$strToReturn .= '<element name="UpdateDate" type="xsd:dateTime"/>';
			$strToReturn .= '<element name="Vision" type="xsd:string"/>';
			$strToReturn .= '<element name="AreaOfExpertise" type="xsd:string"/>';
			$strToReturn .= '<element name="CompletionRatio" type="xsd:float"/>';
			$strToReturn .= '<element name="BudgetPaidRatio" type="xsd:float"/>';
			$strToReturn .= '<element name="PaginationNumber" type="xsd:int"/>';
			$strToReturn .= '<element name="LandingPage" type="xsd:int"/>';
			$strToReturn .= '<element name="__blnRestored" type="xsd:boolean"/>';
			$strToReturn .= '</sequence></complexType>';
			return $strToReturn;
		}

		public static function AlterSoapComplexTypeArray(&$strComplexTypeArray) {
			if (!array_key_exists('TableUserProfile', $strComplexTypeArray)) {
				$strComplexTypeArray['TableUserProfile'] = TableUserProfile::GetSoapComplexTypeXml();
				TableUserProject::AlterSoapComplexTypeArray($strComplexTypeArray);
			}
		}

		public static function GetArrayFromSoapArray($objSoapArray) {
			$objArrayToReturn = array();

			foreach ($objSoapArray as $objSoapObject)
				array_push($objArrayToReturn, TableUserProfile::GetObjectFromSoapObject($objSoapObject));

			return $objArrayToReturn;
		}

		public static function GetObjectFromSoapObject($objSoapObject) {
			$objToReturn = new TableUserProfile();
			if (property_exists($objSoapObject, 'Id'))
				$objToReturn->intId = $objSoapObject->Id;
			if ((property_exists($objSoapObject, 'User')) &&
				($objSoapObject->User))
				$objToReturn->User = TableUserProject::GetObjectFromSoapObject($objSoapObject->User);
			if (property_exists($objSoapObject, 'CompanyUser'))
				$objToReturn->strCompanyUser = $objSoapObject->CompanyUser;
			if (property_exists($objSoapObject, 'CatchPhrase'))
				$objToReturn->strCatchPhrase = $objSoapObject->CatchPhrase;
			if (property_exists($objSoapObject, 'LanguageDescription'))
				$objToReturn->strLanguageDescription = $objSoapObject->LanguageDescription;
			if (property_exists($objSoapObject, 'KeywordDescription'))
				$objToReturn->strKeywordDescription = $objSoapObject->KeywordDescription;
			if (property_exists($objSoapObject, 'Message'))
				$objToReturn->strMessage = $objSoapObject->Message;
			if (property_exists($objSoapObject, 'Location'))
				$objToReturn->strLocation = $objSoapObject->Location;
			if (property_exists($objSoapObject, 'CustomerCount'))
				$objToReturn->intCustomerCount = $objSoapObject->CustomerCount;
			if (property_exists($objSoapObject, 'RepeaterCount'))
				$objToReturn->intRepeaterCount = $objSoapObject->RepeaterCount;
			if (property_exists($objSoapObject, 'WonProjectCount'))
				$objToReturn->intWonProjectCount = $objSoapObject->WonProjectCount;
			if (property_exists($objSoapObject, 'CompletedWonProjectCount'))
				$objToReturn->intCompletedWonProjectCount = $objSoapObject->CompletedWonProjectCount;
			if (property_exists($objSoapObject, 'FailedWonProjectCount'))
				$objToReturn->intFailedWonProjectCount = $objSoapObject->FailedWonProjectCount;
			if (property_exists($objSoapObject, 'PostProjectCount'))
				$objToReturn->intPostProjectCount = $objSoapObject->PostProjectCount;
			if (property_exists($objSoapObject, 'CompletedPostProjectCount'))
				$objToReturn->intCompletedPostProjectCount = $objSoapObject->CompletedPostProjectCount;
			if (property_exists($objSoapObject, 'FailedPostProjectCount'))
				$objToReturn->intFailedPostProjectCount = $objSoapObject->FailedPostProjectCount;
			if (property_exists($objSoapObject, 'BidProjectCount'))
				$objToReturn->intBidProjectCount = $objSoapObject->BidProjectCount;
			if (property_exists($objSoapObject, 'BidProjectCountThisMonth'))
				$objToReturn->intBidProjectCountThisMonth = $objSoapObject->BidProjectCountThisMonth;
			if (property_exists($objSoapObject, 'WonProjectReviewCount'))
				$objToReturn->intWonProjectReviewCount = $objSoapObject->WonProjectReviewCount;
			if (property_exists($objSoapObject, 'WonProjectPositiveReviewCount'))
				$objToReturn->intWonProjectPositiveReviewCount = $objSoapObject->WonProjectPositiveReviewCount;
			if (property_exists($objSoapObject, 'WonProjectNeutralReviewCount'))
				$objToReturn->intWonProjectNeutralReviewCount = $objSoapObject->WonProjectNeutralReviewCount;
			if (property_exists($objSoapObject, 'WonProjectNegativeReviewCount'))
				$objToReturn->intWonProjectNegativeReviewCount = $objSoapObject->WonProjectNegativeReviewCount;
			if (property_exists($objSoapObject, 'PostProjectReviewCount'))
				$objToReturn->intPostProjectReviewCount = $objSoapObject->PostProjectReviewCount;
			if (property_exists($objSoapObject, 'PostProjectPositiveReviewCount'))
				$objToReturn->intPostProjectPositiveReviewCount = $objSoapObject->PostProjectPositiveReviewCount;
			if (property_exists($objSoapObject, 'PostProjectNeutralReviewCount'))
				$objToReturn->intPostProjectNeutralReviewCount = $objSoapObject->PostProjectNeutralReviewCount;
			if (property_exists($objSoapObject, 'PostProjectNegativeReviewCount'))
				$objToReturn->intPostProjectNegativeReviewCount = $objSoapObject->PostProjectNegativeReviewCount;
			if (property_exists($objSoapObject, 'SuspendCount'))
				$objToReturn->intSuspendCount = $objSoapObject->SuspendCount;
			if (property_exists($objSoapObject, 'PaypalEmail'))
				$objToReturn->strPaypalEmail = $objSoapObject->PaypalEmail;
			if (property_exists($objSoapObject, 'LimitedIp'))
				$objToReturn->strLimitedIp = $objSoapObject->LimitedIp;
			if (property_exists($objSoapObject, 'UpdateDate'))
				$objToReturn->dttUpdateDate = new QDateTime($objSoapObject->UpdateDate);
			if (property_exists($objSoapObject, 'Vision'))
				$objToReturn->strVision = $objSoapObject->Vision;
			if (property_exists($objSoapObject, 'AreaOfExpertise'))
				$objToReturn->strAreaOfExpertise = $objSoapObject->AreaOfExpertise;
			if (property_exists($objSoapObject, 'CompletionRatio'))
				$objToReturn->fltCompletionRatio = $objSoapObject->CompletionRatio;
			if (property_exists($objSoapObject, 'BudgetPaidRatio'))
				$objToReturn->fltBudgetPaidRatio = $objSoapObject->BudgetPaidRatio;
			if (property_exists($objSoapObject, 'PaginationNumber'))
				$objToReturn->intPaginationNumber = $objSoapObject->PaginationNumber;
			if (property_exists($objSoapObject, 'LandingPage'))
				$objToReturn->intLandingPage = $objSoapObject->LandingPage;
			if (property_exists($objSoapObject, '__blnRestored'))
				$objToReturn->__blnRestored = $objSoapObject->__blnRestored;
			return $objToReturn;
		}

		public static function GetSoapArrayFromArray($objArray) {
			if (!$objArray)
				return null;

			$objArrayToReturn = array();

			foreach ($objArray as $objObject)
				array_push($objArrayToReturn, TableUserProfile::GetSoapObjectFromObject($objObject, true));

			return unserialize(serialize($objArrayToReturn));
		}

		public static function GetSoapObjectFromObject($objObject, $blnBindRelatedObjects) {
			if ($objObject->objUser)
				$objObject->objUser = TableUserProject::GetSoapObjectFromObject($objObject->objUser, false);
			else if (!$blnBindRelatedObjects)
				$objObject->intUserId = null;
			if ($objObject->dttUpdateDate)
				$objObject->dttUpdateDate = $objObject->dttUpdateDate->__toString(QDateTime::FormatSoap);
			return $objObject;
		}




	}



	/////////////////////////////////////
	// ADDITIONAL CLASSES for QCubed QUERY
	/////////////////////////////////////

	class QQNodeTableUserProfile extends QQNode {
		protected $strTableName = 'table_user_profile';
		protected $strPrimaryKey = 'id';
		protected $strClassName = 'TableUserProfile';
		public function __get($strName) {
			switch ($strName) {
				case 'Id':
					return new QQNode('id', 'Id', 'integer', $this);
				case 'UserId':
					return new QQNode('user_id', 'UserId', 'integer', $this);
				case 'User':
					return new QQNodeTableUserProject('user_id', 'User', 'integer', $this);
				case 'CompanyUser':
					return new QQNode('company_user', 'CompanyUser', 'string', $this);
				case 'CatchPhrase':
					return new QQNode('catch_phrase', 'CatchPhrase', 'string', $this);
				case 'LanguageDescription':
					return new QQNode('language_description', 'LanguageDescription', 'string', $this);
				case 'KeywordDescription':
					return new QQNode('keyword_description', 'KeywordDescription', 'string', $this);
				case 'Message':
					return new QQNode('message', 'Message', 'string', $this);
				case 'Location':
					return new QQNode('location', 'Location', 'string', $this);
				case 'CustomerCount':
					return new QQNode('customer_count', 'CustomerCount', 'integer', $this);
				case 'RepeaterCount':
					return new QQNode('repeater_count', 'RepeaterCount', 'integer', $this);
				case 'WonProjectCount':
					return new QQNode('won_project_count', 'WonProjectCount', 'integer', $this);
				case 'CompletedWonProjectCount':
					return new QQNode('completed_won_project_count', 'CompletedWonProjectCount', 'integer', $this);
				case 'FailedWonProjectCount':
					return new QQNode('failed_won_project_count', 'FailedWonProjectCount', 'integer', $this);
				case 'PostProjectCount':
					return new QQNode('post_project_count', 'PostProjectCount', 'integer', $this);
				case 'CompletedPostProjectCount':
					return new QQNode('completed_post_project_count', 'CompletedPostProjectCount', 'integer', $this);
				case 'FailedPostProjectCount':
					return new QQNode('failed_post_project_count', 'FailedPostProjectCount', 'integer', $this);
				case 'BidProjectCount':
					return new QQNode('bid_project_count', 'BidProjectCount', 'integer', $this);
				case 'BidProjectCountThisMonth':
					return new QQNode('bid_project_count_this_month', 'BidProjectCountThisMonth', 'integer', $this);
				case 'WonProjectReviewCount':
					return new QQNode('won_project_review_count', 'WonProjectReviewCount', 'integer', $this);
				case 'WonProjectPositiveReviewCount':
					return new QQNode('won_project_positive_review_count', 'WonProjectPositiveReviewCount', 'integer', $this);
				case 'WonProjectNeutralReviewCount':
					return new QQNode('won_project_neutral_review_count', 'WonProjectNeutralReviewCount', 'integer', $this);
				case 'WonProjectNegativeReviewCount':
					return new QQNode('won_project_negative_review_count', 'WonProjectNegativeReviewCount', 'integer', $this);
				case 'PostProjectReviewCount':
					return new QQNode('post_project_review_count', 'PostProjectReviewCount', 'integer', $this);
				case 'PostProjectPositiveReviewCount':
					return new QQNode('post_project_positive_review_count', 'PostProjectPositiveReviewCount', 'integer', $this);
				case 'PostProjectNeutralReviewCount':
					return new QQNode('post_project_neutral_review_count', 'PostProjectNeutralReviewCount', 'integer', $this);
				case 'PostProjectNegativeReviewCount':
					return new QQNode('post_project_negative_review_count', 'PostProjectNegativeReviewCount', 'integer', $this);
				case 'SuspendCount':
					return new QQNode('suspend_count', 'SuspendCount', 'integer', $this);
				case 'PaypalEmail':
					return new QQNode('paypal_email', 'PaypalEmail', 'string', $this);
				case 'LimitedIp':
					return new QQNode('limited_ip', 'LimitedIp', 'string', $this);
				case 'UpdateDate':
					return new QQNode('update_date', 'UpdateDate', 'QDateTime', $this);
				case 'Vision':
					return new QQNode('vision', 'Vision', 'string', $this);
				case 'AreaOfExpertise':
					return new QQNode('area_of_expertise', 'AreaOfExpertise', 'string', $this);
				case 'CompletionRatio':
					return new QQNode('completion_ratio', 'CompletionRatio', 'double', $this);
				case 'BudgetPaidRatio':
					return new QQNode('budget_paid_ratio', 'BudgetPaidRatio', 'double', $this);
				case 'PaginationNumber':
					return new QQNode('pagination_number', 'PaginationNumber', 'integer', $this);
				case 'LandingPage':
					return new QQNode('landing_page', 'LandingPage', 'integer', $this);

				case '_PrimaryKeyNode':
					return new QQNode('id', 'Id', 'integer', $this);
				default:
					try {
						return parent::__get($strName);
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}
			}
		}
	}

	class QQReverseReferenceNodeTableUserProfile extends QQReverseReferenceNode {
		protected $strTableName = 'table_user_profile';
		protected $strPrimaryKey = 'id';
		protected $strClassName = 'TableUserProfile';
		public function __get($strName) {
			switch ($strName) {
				case 'Id':
					return new QQNode('id', 'Id', 'integer', $this);
				case 'UserId':
					return new QQNode('user_id', 'UserId', 'integer', $this);
				case 'User':
					return new QQNodeTableUserProject('user_id', 'User', 'integer', $this);
				case 'CompanyUser':
					return new QQNode('company_user', 'CompanyUser', 'string', $this);
				case 'CatchPhrase':
					return new QQNode('catch_phrase', 'CatchPhrase', 'string', $this);
				case 'LanguageDescription':
					return new QQNode('language_description', 'LanguageDescription', 'string', $this);
				case 'KeywordDescription':
					return new QQNode('keyword_description', 'KeywordDescription', 'string', $this);
				case 'Message':
					return new QQNode('message', 'Message', 'string', $this);
				case 'Location':
					return new QQNode('location', 'Location', 'string', $this);
				case 'CustomerCount':
					return new QQNode('customer_count', 'CustomerCount', 'integer', $this);
				case 'RepeaterCount':
					return new QQNode('repeater_count', 'RepeaterCount', 'integer', $this);
				case 'WonProjectCount':
					return new QQNode('won_project_count', 'WonProjectCount', 'integer', $this);
				case 'CompletedWonProjectCount':
					return new QQNode('completed_won_project_count', 'CompletedWonProjectCount', 'integer', $this);
				case 'FailedWonProjectCount':
					return new QQNode('failed_won_project_count', 'FailedWonProjectCount', 'integer', $this);
				case 'PostProjectCount':
					return new QQNode('post_project_count', 'PostProjectCount', 'integer', $this);
				case 'CompletedPostProjectCount':
					return new QQNode('completed_post_project_count', 'CompletedPostProjectCount', 'integer', $this);
				case 'FailedPostProjectCount':
					return new QQNode('failed_post_project_count', 'FailedPostProjectCount', 'integer', $this);
				case 'BidProjectCount':
					return new QQNode('bid_project_count', 'BidProjectCount', 'integer', $this);
				case 'BidProjectCountThisMonth':
					return new QQNode('bid_project_count_this_month', 'BidProjectCountThisMonth', 'integer', $this);
				case 'WonProjectReviewCount':
					return new QQNode('won_project_review_count', 'WonProjectReviewCount', 'integer', $this);
				case 'WonProjectPositiveReviewCount':
					return new QQNode('won_project_positive_review_count', 'WonProjectPositiveReviewCount', 'integer', $this);
				case 'WonProjectNeutralReviewCount':
					return new QQNode('won_project_neutral_review_count', 'WonProjectNeutralReviewCount', 'integer', $this);
				case 'WonProjectNegativeReviewCount':
					return new QQNode('won_project_negative_review_count', 'WonProjectNegativeReviewCount', 'integer', $this);
				case 'PostProjectReviewCount':
					return new QQNode('post_project_review_count', 'PostProjectReviewCount', 'integer', $this);
				case 'PostProjectPositiveReviewCount':
					return new QQNode('post_project_positive_review_count', 'PostProjectPositiveReviewCount', 'integer', $this);
				case 'PostProjectNeutralReviewCount':
					return new QQNode('post_project_neutral_review_count', 'PostProjectNeutralReviewCount', 'integer', $this);
				case 'PostProjectNegativeReviewCount':
					return new QQNode('post_project_negative_review_count', 'PostProjectNegativeReviewCount', 'integer', $this);
				case 'SuspendCount':
					return new QQNode('suspend_count', 'SuspendCount', 'integer', $this);
				case 'PaypalEmail':
					return new QQNode('paypal_email', 'PaypalEmail', 'string', $this);
				case 'LimitedIp':
					return new QQNode('limited_ip', 'LimitedIp', 'string', $this);
				case 'UpdateDate':
					return new QQNode('update_date', 'UpdateDate', 'QDateTime', $this);
				case 'Vision':
					return new QQNode('vision', 'Vision', 'string', $this);
				case 'AreaOfExpertise':
					return new QQNode('area_of_expertise', 'AreaOfExpertise', 'string', $this);
				case 'CompletionRatio':
					return new QQNode('completion_ratio', 'CompletionRatio', 'double', $this);
				case 'BudgetPaidRatio':
					return new QQNode('budget_paid_ratio', 'BudgetPaidRatio', 'double', $this);
				case 'PaginationNumber':
					return new QQNode('pagination_number', 'PaginationNumber', 'integer', $this);
				case 'LandingPage':
					return new QQNode('landing_page', 'LandingPage', 'integer', $this);

				case '_PrimaryKeyNode':
					return new QQNode('id', 'Id', 'integer', $this);
				default:
					try {
						return parent::__get($strName);
					} catch (QCallerException $objExc) {
						$objExc->IncrementOffset();
						throw $objExc;
					}
			}
		}
	}

?>